{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction and guidance","Diet input details","Herd input details","Results","References and assumptions log","Calculations - Data tables","Calculations - Dataset"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":7,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction and guidance","index":0,"n_rows":84,"n_cols":33,"rows_kept":84,"cut":false,"hidden":false,"merged":[[60,2,61,12],[45,12,45,14],[46,12,46,14],[18,2,41,14],[42,2,42,14],[43,2,43,4],[43,5,43,7],[58,8,58,9],[58,10,58,12],[57,2,57,14],[43,8,43,11],[43,12,43,14],[44,12,44,14],[46,8,46,11],[62,2,82,14],[16,2,17,14],[9,2,12,14],[60,13,61,15],[14,2,15,14],[56,2,56,14],[58,2,58,3],[58,4,58,7],[45,5,45,7],[46,5,46,7],[47,2,48,14],[49,2,55,14],[44,2,46,4],[44,5,44,7],[44,8,44,11],[45,8,45,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Pig excreta mass balance model"]
[]
[]
[]
[]
[null,null,"Nutritional Management Best Available Techniques for Pigs \n(click here to see regulations)"]
[]
[null,null,"Best Available Techniques (BAT) Reference Document for the Intensive Rearing of Poultry or Pigs \n(click here to see reference document)"]
[]
[null,null,"Introduction:\n\nFarms with more than 2,000 places for production of pigs (over 30 kg), or with more than 750 places for sows fall in scope of regulations requiring the adoption of Best Available Techniques (BAT) to reduce environmental emissions.  BAT for pig and poultry farms is outlined in a published BAT Conclusions (BATC) document (see link above). BAT 3 requires farms to reduce total nitrogen excreted whilst BAT 4 requires the reduction  of total phosphorus excreted.  The BATC include levels for total nitrogen and total phosphorus excreted, measured per animal place. All permitted farms must meet these levels.  \n\nBAT 24 requires the monitoring of total nitrogen and total phosphorus excreted with two recognised methods: Calculation by using a mass balance or estimation using manure analysis results.  Issued permits contain conditions requiring submission of the derived data on an annual basis.  \n\nThis simple spreadsheet tool has been designed to assist farms in assessing compliance with the new BAT for pigs and follows a mass balance calculation approach. The tool is recognised by the Environment Agency, Natural Resources Wales, Northern Ireland Environment Agency and Scottish Environment Protection Agency.\n\nInstructions:\n\nTo calculate the BAT Emission levels please follow the instructions embedded within each worksheet.  Details of the Herd and Diets need entering in the ‘Herd Input Details’ and ‘Diet Input Details’ worksheets, the emission values and feed intake data will then be calculated in the ‘Results’ worksheet.  Only when all values are completed within the input forms will the BAT values be calculated. \n\nInputs need to accurately reflect your system usage across the year. You should save a copy of your completed calculator tool in case it is requested as part of future permit compliance checks.\n\nYou will need to read the terms of use below and tick the agree box before you can use the tool.  \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"BAT Total Excreted Levels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Parameter",null,null,"Animal category",null,null,"BAT-associated total nitrogen excreted ⁽¹⁾ (kg N excreted/animal place/year)",null,null,null,"BAT-associated total phosphorus excreted ⁽¹⁾  (kg P₂O₅ excreted/animal place/year)"]
[null,null,"Total nutrient excreted",null,null,"Weaners",null,null,"1.5 - 4.0",null,null,null,"1.2 - 2.2"]
[null,null,null,null,null,"Fattening pigs",null,null,"7.0 - 13.0",null,null,null,"3.5 - 5.4"]
[null,null,null,null,null,"Sows (including Piglets)",null,null,"17.0 - 30.0 ",null,null,null,"9.0 - 15.0"]
[null,null,"(1) The lower end of the range can be achieved by using a combination of techniques."]
[]
[null,null,"Acknowledgements:\n\nThis simple spreadsheet tool has been designed, based on an update of the previous model (created by AIC), by Ricardo. This work model has been developed on behalf of the Environment Agency alongside a partnership of industry bodies (AHDB, NPA) to assist farms in assessing compliance with the new BAT for pigs. The tool has been peer reviewed by experts in feed nutrition and is recognised by the Environment Agency, Natural Resources Wales, Northern Ireland Environment Agency and Scottish Environment Protection Agency."]
[]
[]
[]
[]
[]
[]
[null,null,"Terms of use"]
[null,null,"Enter your installation name and permit reference number in the white boxes below:"]
[null,null,"Installation Name:",null,null,null,null,null,"Permit Number:"]
[]
[null,null,"To use the calculator, first read the terms of use below and tick the box to confirm your acceptance \n(the calculator will not work if this box is not ticked)",null,null,null,null,null,null,null,null,null,null,"Tick to confirm\nacceptance",null,null,false]
[]
[null,null,"Terms of use\n\nIn making use of the BAT Emission Calculator (“the Calculator”), I agree to and accept the following:\n1. I understand that the Calculator has been made available to me by the PARTNERS (Environment Agency, AHDB, NPA) (“the Partners”), and that whilst the Partners have used their best endeavours to ensure the accuracy of the Calculator, the Partners accept no liability or responsibility whatsoever for any errors or omissions in the Calculator.\n2. I understand that, so far as is permitted in law, the Partners accept no liability or responsibility whatsoever for any losses, financial penalties or other consequential losses howsoever arising from my use of the Calculator.\n3. It is my responsibility to ensure that the data that I input into the Calculator is accurate and correct.\n4. I accept that the Partners and their employees and agents do not have sufficient knowledge of my individual farm or business to provide advice as to my individual requirements.\n5. I understand that the Calculator is no substitute for professional advice and that I should seek professional advice as to my compliance requirements under any relevant legislation.\n6. I agree that it is my responsibility to ensure that I comply with the relevant compliance requirements under any relevant legislation.\n7. I agree that English law applies to my use of the Calculator, and the Courts of England and Wales have jurisdiction to hear any disputes arising from my use of the Calculator.\n8. I agree that if I am using the Calculator in a professional capacity for the benefit of a client, it is my responsibility as my client’s professional adviser to advise my client on his / her compliance with the relevant requirements under any relevant legislation."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Please note: If further details on the data inputs and calculations are required, calculation sheets can be unlocked within the model by right clicking the 'Introduction and guidance' tab, clicking 'Unhide...' highlighting each sheet and clicking 'OK'."]

{"sheet":"Diet input details","index":1,"n_rows":95,"n_cols":7,"rows_kept":95,"cut":false,"hidden":false,"merged":[[3,6,30,10],[22,1,23,1],[40,1,40,4],[41,1,42,1],[3,1,3,4],[4,4,6,4],[4,2,6,2],[4,3,6,3],[4,1,6,1],[22,2,22,4]]}
[null,null,null,null,"Input data - diet details"]
[]
[null,"Diet input table 1:"]
[null,"Diet Details",null,null,null,null,"\nDiet details input instructions\n\nDiet input table 1:\nPlease input protein and phosphorus content of the feed for each growth stage (values can be found on all feed declaration tickets) in the white boxes in the \"Diet Details\" table.\nIf the diets are the same (e.g. Creep 1 and 2), then please put the same protein and phosphorus values in both respective sets of boxes.\nIf feed diet groups are not used then leave the cells blank and move on to the next used group.\n\nDiet input table 2:\nEnter the total feed input per pig sold in kg for each feed stage. If exact figures are not known, these can be estimated from total feed consumed divided by the number of pigs.\nThe weaner category covers weaning and earlier growing phases from start (approx. 7kg) to 30kg.\nThe fattening category covers growing and fattening/finishing phases from over 30kg to 120kg/Slaughter. \nIf feed diet groups are not used then leave the cells blank and move on to the next used group.\n\nDiet input table 3:\nTick the appropriate box if phytase is used as a feed additive in that system."]
[null,"Type","Crude protein\n(%)","Nitrogen\n(%)","Phosphorus\n(%)"]
[]
[]
[null,"Gilt rear",null,{"$f":"C8/6.25","v":0}]
[null,"Dry sow",null,0]
[null,"Lact sow",null,0]
[null,"Gilt lact",null,0]
[null,"Creep 1",null,0]
[null,"Creep 2",null,0]
[null,"Creep 3",null,0]
[null,"Grow 1",null,0]
[null,"Grow 2",null,0]
[null,"Grow 3",null,0]
[null,"Fin 1",null,0]
[null,"Fin 2",null,0]
[null,"Fin 3",null,0]
[]
[null,"Diet input table 2:"]
[null,"Type","Feed input per pig sold (kg)"]
[null,null,"Weaner\n(7kg-30kg)","Fattening\n(Over 30kg-Slaughter)","Sow + piglets\n(Sow incl. litter)"]
[null,"Gilt rear"]
[null,"Dry sow"]
[null,"Lact sow"]
[null,"Gilt lact"]
[null,"Creep 1"]
[null,"Creep 2"]
[null,"Creep 3"]
[null,"Grow 1"]
[null,"Grow 2"]
[null,"Grow 3"]
[null,"Fin 1"]
[null,"Fin 2"]
[null,"Fin 3"]
[null,"Total feed (kg)",{"$f":"SUM(C29:C33)","v":0},{"$f":"SUM(D33:D37)","v":0},{"$f":"SUM(E25:E29)","v":0}]
[]
[null,"Diet input table 3:"]
[null,"Nutrient Retention"]
[null,"Phytase feed additive value","Weaner\n(7kg-30kg)","Fattening\n(Over 30kg-Slaughter)","Sow + piglets\n(Sow incl. litter)"]
[]
[]
[]
[]
[null,null,false]
[null,null,false]
[null,null,false]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,false]
[null,false]
[null,false]

{"sheet":"Herd input details","index":2,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,1,3,3],[12,1,12,3],[18,1,18,3],[2,6,23,8]]}
[null,null,"Input data - herd details"]
[]
[null,"Herd input table 1:",null,null,null,null,"\nHerd details input instructions\n\nHerd input table 1:\nEnter details of the breeding herd and replacement details in the white boxes. Where a pig type is not present leave the cells blank.\n\nHerd input table 2:\nEnter the details of production cycle in the white boxes.\n\nHerd input table 3:\nEnter the details of the days in each phase in the white boxes.\nThe weaner category covers weaning and earlier growing phases from start (approx. 7kg) \nto 30kg.\nThe fattening category covers growing and fattening/finishing phases from over 30kg to 120kg/Slaughter."]
[null,"Sow input"]
[null,"Sows and gilts - total in herd"]
[null,"Farrowing + dry sow places"]
[null,"Pigs sold per sow and gilt per year"]
[null,"Replacement rate","(%)"]
[null,"Weight replacement gilt","(kg)"]
[null,"Liveweight cull sow","(kg)"]
[]
[null,"Herd input table 2:"]
[null,"Pig weights (kg)"]
[null,"Wean weight","(kg)"]
[null,"Weight transfer to fattening","(kg)"]
[null,"Slaughter weight (liveweight)","(kg)"]
[]
[null,"Herd input table 3:"]
[null,"Days in phase (per pig)"]
[null,"Days in weaner phase (approx. 7kg-30kg)","(d)"]
[null,"Days weaner empty (approx. 7kg-30kg)","(d)"]
[null,"Days in fattener phase (over 30kg-slaughter)","(d)"]
[null,"Days fattener empty ","(d)"]

{"sheet":"Results","index":3,"n_rows":68,"n_cols":10,"rows_kept":68,"cut":false,"hidden":false,"merged":[[65,1,65,2],[66,1,66,2],[67,1,67,2],[61,1,61,2],[62,1,62,2],[64,1,64,2],[63,1,63,2],[52,3,52,6],[58,1,58,2],[59,1,59,2],[60,1,60,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[50,1,50,2],[54,1,54,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[3,1,3,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[14,3,14,6],[15,5,15,6],[15,3,15,4],[41,3,41,5],[16,3,16,4],[17,3,17,4],[18,3,18,4],[16,5,16,6],[17,5,17,6],[18,5,18,6],[22,1,22,4],[22,6,22,9],[7,8,17,12],[7,3,7,6],[10,3,10,4],[11,3,11,4],[10,5,10,6],[11,5,11,6],[8,3,8,4],[9,3,9,4],[8,5,8,6],[9,5,9,6]]}
[null,null,null,null,null,"Export data - emission levels"]
[]
[]
[null,"Installation name:",null,{"$f":"'Introduction and guidance'!E59","v":0},null,"Permit number:",null,{"$f":"'Introduction and guidance'!K59","v":0}]
[]
[]
[]
[null,null,null,"BAT Emission Level",null,null,null,null,"\nResults sheet instructions\n\nBased on the data entered within the diet and herd detail input sheets the systems performance and emissions data are calculated here. \nThese tables can be used to derive BAT compliance under the regulations (2010/75/EU IPPC).  As well as calculating the total N and P intake and overall unit performance information.\n\nUse the data given in this box to demonstrate compliance with the nitrogen and phosphorus excretion levels. \nThe cells are colour coded to confirm compliance, If the cell is green the emission levels are compliant, if it turns red the emission levels are non-compliant.  Upper limit values are provided in the introduction.\n\nFurther details on the nitrogen and phosphorus intake (kg/pig sold) can be seen in the tables below. \n\nSummary tables providing a suggestion of performance levels and annual feed usage based on the data input by the user are found at the bottom of the sheet."]
[null,null,null,"Nitrogen excreted\nPer animal place (kg N/ Year)",null,"Phosphorus excreted\nPer animal place (kg P/ Year)"]
[null,null,"Weaner\n(7kg-30kg)",{"$f":"'Calculations - Dataset'!F47","v":{"$error":"#DIV/0!"}},null,{"$f":"'Calculations - Dataset'!H48","v":{"$error":"#DIV/0!"}}]
[null,null,"Fattening\n(Over 30kg-Slaughter)",{"$f":"'Calculations - Dataset'!F66","v":{"$error":"#DIV/0!"}},null,{"$f":"'Calculations - Dataset'!H67","v":{"$error":"#DIV/0!"}}]
[null,null,"Sow + piglets*",{"$f":"'Calculations - Dataset'!E97","v":{"$error":"#DIV/0!"}},null,{"$f":"'Calculations - Dataset'!G98","v":{"$error":"#DIV/0!"}}]
[null,null,"*calculated assuming a sow is equivalent to a pig place."]
[]
[null,null,null,"Percentage of BAT upper Limit"]
[null,null,null,"Percentage on N BAT upper limit",null,"Percentage on P BAT upper limit"]
[null,null,"Weaner\n(7kg-30kg)",{"$f":"D10/4","v":{"$error":"#DIV/0!"}},null,{"$f":"F10/2.2","v":{"$error":"#DIV/0!"}}]
[null,null,"Fattening\n(Over 30kg-Slaughter)",{"$f":"D11/13","v":{"$error":"#DIV/0!"}},null,{"$f":"F11/5.4","v":{"$error":"#DIV/0!"}}]
[null,null,"Sow + piglets*",{"$f":"D12/30","v":{"$error":"#DIV/0!"}},null,{"$f":"F12/15","v":{"$error":"#DIV/0!"}}]
[null,null,"*calculated assuming a sow is equivalent to a pig place."]
[]
[]
[null,"Nitrogen intake \n(kg/pig sold)",null,null,null,null,"Phosphorus intake\n (kg/pig sold)"]
[null,"Type","Weaner\n(7kg-30kg)","Fattening\n(Over 30kg-Slaughter)","Sow + piglets",null,"Type","Weaner\n(7kg-30kg)","Fattening\n(Over 30kg-Slaughter)","Sow + piglets"]
[null,"Gilt rear",null,null,{"$f":"'Calculations - Dataset'!I8","v":0},null,"Gilt rear",null,null,{"$f":"'Calculations - Dataset'!L8","v":0}]
[null,"Dry sow",null,null,{"$f":"'Calculations - Dataset'!I9","v":0},null,"Dry sow",null,null,{"$f":"'Calculations - Dataset'!L9","v":0}]
[null,"Lact sow",null,null,{"$f":"'Calculations - Dataset'!I10","v":0},null,"Lact sow",null,null,{"$f":"'Calculations - Dataset'!L10","v":0}]
[null,"Gilt lact",null,null,{"$f":"'Calculations - Dataset'!I11","v":0},null,"Gilt lact",null,null,{"$f":"'Calculations - Dataset'!L11","v":0}]
[null,"Creep 1",{"$f":"'Calculations - Dataset'!G12","v":0},null,{"$f":"'Calculations - Dataset'!I12","v":0},null,"Creep 1",{"$f":"'Calculations - Dataset'!J12","v":0},null,{"$f":"'Calculations - Dataset'!L12","v":0}]
[null,"Creep 2",{"$f":"'Calculations - Dataset'!G13","v":0},null,{"$f":"'Calculations - Dataset'!I13","v":0},null,"Creep 2",{"$f":"'Calculations - Dataset'!J13","v":0},null,{"$f":"'Calculations - Dataset'!L13","v":0}]
[null,"Creep 3",{"$f":"'Calculations - Dataset'!G14","v":0},null,null,null,"Creep 3",{"$f":"'Calculations - Dataset'!J14","v":0}]
[null,"Grow 1",{"$f":"'Calculations - Dataset'!G15","v":0},null,null,null,"Grow 1",{"$f":"'Calculations - Dataset'!J15","v":0}]
[null,"Grow 2",{"$f":"'Calculations - Dataset'!G16","v":0},{"$f":"'Calculations - Dataset'!H16","v":0},null,null,"Grow 2",{"$f":"'Calculations - Dataset'!J16","v":0},{"$f":"'Calculations - Dataset'!K16","v":0}]
[null,"Grow 3",null,{"$f":"'Calculations - Dataset'!H17","v":0},null,null,"Grow 3",null,{"$f":"'Calculations - Dataset'!K17","v":0}]
[null,"Fin 1",null,{"$f":"'Calculations - Dataset'!H18","v":0},null,null,"Fin 1",null,{"$f":"'Calculations - Dataset'!K18","v":0}]
[null,"Fin 2",null,{"$f":"'Calculations - Dataset'!H19","v":0},null,null,"Fin 2",null,{"$f":"'Calculations - Dataset'!K19","v":0}]
[null,"Fin 3",null,{"$f":"'Calculations - Dataset'!H20","v":0},null,null,"Fin 3",null,{"$f":"'Calculations - Dataset'!K20","v":0}]
[null,"Total",{"$f":"SUM(C25:C37)","v":0},{"$f":"SUM(D25:D37)","v":0},{"$f":"SUM(E25:E37)","v":0},null,"Total",{"$f":"SUM(H25:H37)","v":0},{"$f":"SUM(I25:I37)","v":0},{"$f":"SUM(J25:J37)","v":0}]
[]
[]
[]
[null,null,null,"Production performance information "]
[null,null,null,"Weaner\n(7kg-30kg)","Fattening\n(Over 30kg-Slaughter)","Sow + piglets"]
[null,"Daily gain (g/day)",null,{"$f":"1000*('Herd input details'!D15-'Herd input details'!D14)/'Herd input details'!D20","v":{"$error":"#DIV/0!"}},{"$f":"1000*('Herd input details'!D16-'Herd input details'!D15)/'Herd input details'!D22","v":{"$error":"#DIV/0!"}}]
[null,"Feed Conversion Ratio (FCR)",null,{"$f":"+'Diet input details'!C38/('Herd input details'!D15-'Herd input details'!D14)","v":{"$error":"#DIV/0!"}},{"$f":"+'Diet input details'!D38/('Herd input details'!D16-'Herd input details'!D15)","v":{"$error":"#DIV/0!"}}]
[null,"Gilt feed/s/annum (t)",null,null,null,{"$f":"+'Diet input details'!E25*'Herd input details'!D7","v":0}]
[null,"Dry sow feed/s/annum (t)",null,null,null,{"$f":"+'Diet input details'!E26*'Herd input details'!D7","v":0}]
[null,"Lact sow feed/s/annum (t)",null,null,null,{"$f":"+('Diet input details'!E27+'Diet input details'!E28)*'Herd input details'!D7","v":0}]
[null,"Total sow feed/s /annum (t)",null,null,null,{"$f":"+F47+F48+F46","v":0}]
[null,"Batches/annum",null,{"$f":"365/('Herd input details'!D20+'Herd input details'!D21)","v":{"$error":"#DIV/0!"}},{"$f":"365/('Herd input details'!D22+'Herd input details'!D23)","v":{"$error":"#DIV/0!"}}]
[null,"Occupancy (%)",null,{"$f":"100*'Herd input details'!D20/('Herd input details'!D20+'Herd input details'!D21)","v":{"$error":"#DIV/0!"}},{"$f":"100*'Herd input details'!D22/('Herd input details'!D22+'Herd input details'!D23)","v":{"$error":"#DIV/0!"}},{"$f":"100*'Herd input details'!D5/'Herd input details'!D6","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Annual feed usage (t)"]
[null,null,null,"Weaner\n(7kg-30kg)","Fattening\n(Over 30kg-Slaughter)","Sow + piglets","Total"]
[null,"Gilt rear",null,null,null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!E25*0.001","v":0},{"$f":"SUM(D55:F55)","v":0}]
[null,"Dry sow",null,null,null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!E26*0.001","v":0},{"$f":"SUM(D56:F56)","v":0}]
[null,"Lact sow",null,null,null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!E27*0.001","v":0},0]
[null,"Gilt lact",null,null,null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!E28*0.001","v":0},0]
[null,"Creep 1",null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!C29*0.001","v":0},null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!E29*0.001","v":0},0]
[null,"Creep 2",null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!C30*0.001","v":0},null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!E30*0.001","v":0},0]
[null,"Creep 3",null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!C31*0.001","v":0},null,null,{"$f":"SUM(D61:F61)","v":0}]
[null,"Grow 1",null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!C32*0.001","v":0},null,null,{"$f":"SUM(D62:F62)","v":0}]
[null,"Grow 2",null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!C33*0.001","v":0},{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!D33*0.001","v":0},null,{"$f":"SUM(D63:F63)","v":0}]
[null,"Grow 3",null,null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!D34*0.001","v":0},null,{"$f":"SUM(D64:F64)","v":0}]
[null,"Fin 1",null,null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!D35*0.001","v":0},null,0]
[null,"Fin 2",null,null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!D36*0.001","v":0},null,{"$f":"SUM(D66:F66)","v":0}]
[null,"Fin 3",null,null,{"$f":"'Herd input details'!$D$5*'Herd input details'!$D$7*'Diet input details'!D37*0.001","v":0},null,{"$f":"SUM(D67:F67)","v":0}]
[null,"Total Annual (t)",null,{"$f":"SUM(D55:D67)","v":0},{"$f":"SUM(E55:E67)","v":0},{"$f":"SUM(F55:F67)","v":0},{"$f":"SUM(G55:G67)","v":0}]

{"sheet":"References and assumptions log","index":4,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["References and assumptions log"]
[]
["Unique ID","Description with key details ","Location in workbook","Link to evidence","Date of last update","Initials","Methodology behind assumption","Assumptions","Any other comments","Reference or assumption"]
["Pig 01","Nitrogen and Phosphorus retention factors in pigs",{"$f":"CELL(\"address\",Table2[[#Headers],[Type]])","v":"'[Pig_Model draft_V4.xlsm]Calculations - Data tables'!$A$7"},"van der Peet-Schwering, C.M.C., (1999), Nitrogen and phosphorus consumption, utilisation and losses in\npig production: The Netherlands, Available from: PII: S0301-6226(99)00010-X | Elsevier Enhanced Reader","2023-03-02","LR","This data has been used to calculate the nitrogen and phosphorus retained in the body mass of pigs at each stage of production","None","These are based off the original models produced.  If more appropriate factors are discovered this can/should be updated","Reference"]
["Pig 02","Nitrogen/Protein conversion factor ",{"$f":"CELL(\"address\",Table419[[#Headers],[Protein to nitrogen conversion factor:]])","v":"'[Pig_Model draft_V4.xlsm]Calculations - Data tables'!$A$20"},"FAO (N.D>) https://www.fao.org/3/y5022e/y5022e03.htm#:~:text=On%20the%20basis%20of%20early,nitrogen%20content%20into%20protein%20content.","2023-03-02","LR","This value is used to convert between protein and nitrogen values ","Does not consider specifics of individual feeds but is a standardised factor used within the industry.","None","Reference"]
["Pig 03","Addition of phytase to diet",{"$f":"CELL(\"address\",Table3[[#Headers],[Column1]])","v":"'[Pig_Model draft_V4.xlsm]Calculations - Data tables'!$A$26"},"Bentley et al. (2015) Development and evaluation of low-phytate wheat germplasm to reduce diffuse phosphate pollution from pig and poultry production units, AHDB.  Available from: https://projectblue.blob.core.windows.net/media/Default/Research%20Papers/Cereals%20and%20Oilseed/rd-2005-3167.pdf","2023-03-02","LR","This data has been used to determine retention rate of phosphorus when phytase has been included in the diet ","Phytase is assumed to have no impact on nitrogen digestion as based on reviewed literature.  \nThe inclusion of phytase in the diet is assumed to be either absent (i.e. no impact on the excretion level of phosphorus) or present (from the literature reviewed (BREF) this is likely to be 0.1%)","This data allowed an estimation of the impact on excreted P to be calculated.  This reduction factor was applied to excreta P levels","Reference"]
["Pig 04","Addition of probiotics ",{"$f":"CELL(\"address\",Table19[[#Headers],[Type]])","v":"'[Pig_Model draft_V4.xlsm]Calculations - Data tables'!$A$34"},"JRC (2017), Best Available Techniques (BAT) \nReference Document for the \nIntensive Rearing of Poultry or Pigs - Section 4.3.6.2 (Table 4.27), Available from: https://data.europa.eu/doi/10.2760/020485","2023-03-02","LR","This data may be used to calculate excreta nitrogen and phosphorus, if probiotics are included in diet","Probiotics have not been used in the calculations.  With review of the available literature and evidence probiotics have not been found to be a common additive to feeds.","This can be updated going forward should further evidence/input be found.  ","Reference"]
["Pig 05","Addition of Benzoic acid",{"$f":"CELL(\"address\",Table20[[#Headers],[Column1]])","v":"'[Pig_Model draft_V4.xlsm]Calculations - Data tables'!$A$42"},"Best Available Techniques (BAT) \nReference Document for the \nIntensive Rearing of Poultry or Pigs, France (2010), Available from: https://data.europa.eu/doi/10.2760/020485","2023-03-02","LR","None ","Assumed to have no impact on nitrogen or phosphorus excretion values","Benzoic acid is a feed additive to pig feed that can reduce emissions of ammonia from manure.  It doesn't however have an impact on digestibility or retention of nutrients in the pig and no effect on level excreted.  ","Assumption"]

{"sheet":"Calculations - Data tables","index":5,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":true,"merged":[[32,4,32,6],[32,1,32,3]]}
["Data tables holding background data"]
[]
["Nitrogen and Phosphorus Retention in pigs"]
["Source:","Pig 01","van der Peer-Schwering, C.M.C., (1999)"]
["This table is providing the basis for calculating the protein and phosphorus content of pigs.  The protein content is the percentage of the liveweight of the pig which is comprised of protein at the start and end of the three main phases of the production cycle.  The phosphorus content is calculated used the allometric function shown (taken from van der Peet-Schwering, C.M.C., (1999)), which is also based on the pig liveweight.  "]
[]
["Type","Start/End","Protein (%)","Phosphorus (%)"]
["Weaners","Start",18.5,"(EXP(1.494)*((Body weight)^1.108)*(((Body weight^(-0.018))^(LN(Body weight))))/1000)"]
[null,"End",19,"(EXP(1.494)*((Body weight)^1.108)*(((Body weight^(-0.018))^(LN(Body weight))))/1000)"]
["Finishers","Start",18.600000000000001,"(EXP(1.494)*((Body weight)^1.108)*(((Body weight^(-0.018))^(LN(Body weight))))/1000)"]
[null,"End",18.600000000000001,"(EXP(1.494)*((Body weight)^1.108)*(((Body weight^(-0.018))^(LN(Body weight))))/1000)"]
["Sows","Start",18,"(EXP(1.494)*((Body weight)^1.108)*(((Body weight^(-0.018))^(LN(Body weight))))/1000)"]
[null,"End",16,"(EXP(1.494)*((Body weight)^1.108)*(((Body weight^(-0.018))^(LN(Body weight))))/1000)"]
[]
[]
["Protein/Nitrogen Conversion Factor"]
["Source: ","Pig 02","AHDB (2015)"]
["Factor to convert crude protein content to nitrogen content"]
[]
["Protein to nitrogen conversion factor:"]
[6.25]
[]
["Impact of phytase included in diet "]
["Source:","Pig 03"]
[]
["Column1","Phytase (+)","Phytase (-)","Reduction in excreted P (%)"]
["Faecal Phosphorous as (%) of Intake",95.7,118.7,-19.376579612468408]
[]
[]
["Addition of probiotics"]
["Source:","Pig 04","BREF - 4.3.6.2 (Table 4.27) "]
[]
[null,"Excreted N",null,null,"Excreted P2O5"]
["Type","g of Nitrogen per \nkg of Liveweight","kg of Nitrogen per sow per year","kg of Nitrogen per pig","g of P2O5 per kg of LW","kg of P2O5 per sow per year","kg of P2O5 per pig"]
["Lactobacillus",1.1499999999999999,-2.29,-0.12,-0.65,-2.02,-6.8000000000000005E-2]
["Enterococcus","No Information ",-2.86,-0.14699999999999999,"No Information ",-2.52,-8.5000000000000006E-2]
[]
[]
["Addition of benzoic acid"]
["Source:","Pig 05","France (2010)"]
[]
["Column1","Benzoic Acid included in diet (%)","Feed Conversion Ratio Reduction"]
["Whole period of fattening observed in the finishing period",0.5,0.14000000000000001]

{"sheet":"Calculations - Dataset","index":6,"n_rows":126,"n_cols":12,"rows_kept":126,"cut":false,"hidden":true,"merged":[[5,1,5,2],[5,3,5,5],[5,6,5,8],[5,9,5,11],[103,1,103,2],[103,3,103,4]]}
["Calculations"]
[]
["Table 1. Feed Summary Calculations"]
["Source: ","Diet and Herd Input Sheets"]
[]
[null,"Feed Composition (%)",null,"Feed Intake (kg/pig)",null,null,"Nitrogen Intake (kg/pig)",null,null,"Phosphorus Intake (kg/pig)"]
["Pig group","Nitrogen (%)","Phosphorus (%)","Weaner (Feed intake)","Fattener (Feed intake)","Sow + Piglets  (Feed intake)","Weaner (Nitrogen Intake)","Fattener (Nitrogen Intake)","Sow + Piglets (Nitrogen Intake)","Weaner (Phosphorus Intake)","Fattener (Phosphorus Intake)","Sow  + Piglets (Phosphorus Intake)"]
["Gilt rear",{"$f":"'Diet input details'!D8","v":0},{"$f":"'Diet input details'!E8","v":0},{"$f":"'Diet input details'!C25","v":0},{"$f":"'Diet input details'!D25","v":0},{"$f":"'Diet input details'!E25","v":0},{"$f":"D8*B8*0.01","v":0},{"$f":"E8*B8*0.01","v":0},{"$f":"F8*B8*0.01","v":0},{"$f":"D8*C8*0.01","v":0},{"$f":"E8*C8*0.01","v":0},{"$f":"F8*C8*0.01","v":0}]
["Dry sow",{"$f":"'Diet input details'!D9","v":0},{"$f":"'Diet input details'!E9","v":0},{"$f":"'Diet input details'!C26","v":0},{"$f":"'Diet input details'!D26","v":0},{"$f":"'Diet input details'!E26","v":0},{"$f":"D9*B9*0.01","v":0},{"$f":"E9*B9*0.01","v":0},{"$f":"F9*B9*0.01","v":0},{"$f":"D9*C9*0.01","v":0},{"$f":"E9*C9*0.01","v":0},{"$f":"F9*C9*0.01","v":0}]
["Lact sow",{"$f":"'Diet input details'!D10","v":0},{"$f":"'Diet input details'!E10","v":0},{"$f":"'Diet input details'!C27","v":0},{"$f":"'Diet input details'!D27","v":0},{"$f":"'Diet input details'!E27","v":0},{"$f":"D10*B10*0.01","v":0},{"$f":"E10*B10*0.01","v":0},{"$f":"F10*B10*0.01","v":0},{"$f":"D10*C10*0.01","v":0},{"$f":"E10*C10*0.01","v":0},{"$f":"F10*C10*0.01","v":0}]
["Gilt lact",{"$f":"'Diet input details'!D11","v":0},{"$f":"'Diet input details'!E11","v":0},{"$f":"'Diet input details'!C28","v":0},{"$f":"'Diet input details'!D28","v":0},{"$f":"'Diet input details'!E28","v":0},{"$f":"D11*B11*0.01","v":0},{"$f":"E11*B11*0.01","v":0},{"$f":"F11*B11*0.01","v":0},{"$f":"D11*C11*0.01","v":0},{"$f":"E11*C11*0.01","v":0},{"$f":"F11*C11*0.01","v":0}]
["Creep 1",{"$f":"'Diet input details'!D12","v":0},{"$f":"'Diet input details'!E12","v":0},{"$f":"'Diet input details'!C29","v":0},{"$f":"'Diet input details'!D29","v":0},{"$f":"'Diet input details'!E29","v":0},{"$f":"D12*B12*0.01","v":0},{"$f":"E12*B12*0.01","v":0},{"$f":"F12*B12*0.01","v":0},{"$f":"D12*C12*0.01","v":0},{"$f":"E12*C12*0.01","v":0},{"$f":"F12*C12*0.01","v":0}]
["Creep 2",{"$f":"'Diet input details'!D13","v":0},{"$f":"'Diet input details'!E13","v":0},{"$f":"'Diet input details'!C30","v":0},{"$f":"'Diet input details'!D30","v":0},{"$f":"'Diet input details'!E30","v":0},{"$f":"D13*B13*0.01","v":0},{"$f":"E13*B13*0.01","v":0},{"$f":"F13*B13*0.01","v":0},{"$f":"D13*C13*0.01","v":0},{"$f":"E13*C13*0.01","v":0},{"$f":"F13*C13*0.01","v":0}]
["Creep 3",{"$f":"'Diet input details'!D14","v":0},{"$f":"'Diet input details'!E14","v":0},{"$f":"'Diet input details'!C31","v":0},{"$f":"'Diet input details'!D31","v":0},{"$f":"'Diet input details'!E31","v":0},{"$f":"D14*B14*0.01","v":0},{"$f":"E14*B14*0.01","v":0},{"$f":"F14*B14*0.01","v":0},{"$f":"D14*C14*0.01","v":0},{"$f":"E14*C14*0.01","v":0},{"$f":"F14*C14*0.01","v":0}]
["Grow 1",{"$f":"'Diet input details'!D15","v":0},{"$f":"'Diet input details'!E15","v":0},{"$f":"'Diet input details'!C32","v":0},{"$f":"'Diet input details'!D32","v":0},{"$f":"'Diet input details'!E32","v":0},{"$f":"D15*B15*0.01","v":0},{"$f":"E15*B15*0.01","v":0},{"$f":"F15*B15*0.01","v":0},{"$f":"D15*C15*0.01","v":0},{"$f":"E15*C15*0.01","v":0},{"$f":"F15*C15*0.01","v":0}]
["Grow 2",{"$f":"'Diet input details'!D16","v":0},{"$f":"'Diet input details'!E16","v":0},{"$f":"'Diet input details'!C33","v":0},{"$f":"'Diet input details'!D33","v":0},{"$f":"'Diet input details'!E33","v":0},{"$f":"D16*B16*0.01","v":0},{"$f":"E16*B16*0.01","v":0},{"$f":"F16*B16*0.01","v":0},{"$f":"D16*C16*0.01","v":0},{"$f":"E16*C16*0.01","v":0},{"$f":"F16*C16*0.01","v":0}]
["Grow 3",{"$f":"'Diet input details'!D16","v":0},{"$f":"'Diet input details'!E16","v":0},{"$f":"'Diet input details'!C34","v":0},{"$f":"'Diet input details'!D34","v":0},{"$f":"'Diet input details'!E34","v":0},{"$f":"D17*B17*0.01","v":0},{"$f":"E17*B17*0.01","v":0},{"$f":"F17*B17*0.01","v":0},{"$f":"D17*C17*0.01","v":0},{"$f":"E17*C17*0.01","v":0},{"$f":"F17*C17*0.01","v":0}]
["Fin 1",{"$f":"'Diet input details'!D18","v":0},{"$f":"'Diet input details'!E18","v":0},{"$f":"'Diet input details'!C35","v":0},{"$f":"'Diet input details'!D35","v":0},{"$f":"'Diet input details'!E35","v":0},{"$f":"D18*B18*0.01","v":0},{"$f":"E18*B18*0.01","v":0},{"$f":"F18*B18*0.01","v":0},{"$f":"D18*C18*0.01","v":0},{"$f":"E18*C18*0.01","v":0},{"$f":"F18*C18*0.01","v":0}]
["Fin 2",{"$f":"'Diet input details'!D19","v":0},{"$f":"'Diet input details'!E19","v":0},{"$f":"'Diet input details'!C36","v":0},{"$f":"'Diet input details'!D36","v":0},{"$f":"'Diet input details'!E36","v":0},{"$f":"D19*B19*0.01","v":0},{"$f":"E19*B19*0.01","v":0},{"$f":"F19*B19*0.01","v":0},{"$f":"D19*C19*0.01","v":0},{"$f":"E19*C19*0.01","v":0},{"$f":"F19*C19*0.01","v":0}]
["Fin 3",{"$f":"'Diet input details'!D20","v":0},{"$f":"'Diet input details'!E20","v":0},{"$f":"'Diet input details'!C37","v":0},{"$f":"'Diet input details'!D37","v":0},{"$f":"'Diet input details'!E37","v":0},{"$f":"D20*B20*0.01","v":0},{"$f":"E20*B20*0.01","v":0},{"$f":"F20*B20*0.01","v":0},{"$f":"D20*C20*0.01","v":0},{"$f":"E20*C20*0.01","v":0},{"$f":"F20*C20*0.01","v":0}]
[]
[]
["Table 2. Sum on N and P intake per pig type"]
["Source: ","Table 1. Feed summary calculations"]
[]
["Type","Sum of N Intake (kg/pig)","Sum of P Intake (kg/pig)"]
["Weaner ",{"$f":"SUM(G12:G16)","v":0},{"$f":"SUM(J12:J16)","v":0}]
["Fattener",{"$f":"SUM(H16:H20)","v":0},{"$f":"SUM(K16:K20)","v":0}]
["Sow + piglets ",{"$f":"SUM(I8:I12)","v":0},{"$f":"SUM(L8:L12)","v":0}]
[]
[]
["Table 3. Weaner feed input calculations"]
["Source: ","Pig 01 and Herd input details "]
["This table contains the feed input calculations for weaners.  "]
[]
["Column1","Weight (kg)","Protein in body mass (%)","Protein in body mass (kg)","Nitrogen in body mass (kg)","Phosphorus in body mass (kg)"]
["Start",{"$f":"'Herd input details'!D14","v":0},18.5,{"$f":"B37*C37*0.01","v":0},{"$f":"D37/6.25","v":0},{"$f":"+(EXP(1.494)*((B37)^1.108)*(((B37^(-0.018))^(LN(B37))))/1000)","v":{"$error":"#DIV/0!"}}]
["End of phase (transfer)",{"$f":"'Herd input details'!D15","v":0},19,{"$f":"B38*C38*0.01","v":0},{"$f":"D38/6.25","v":0},{"$f":"+(EXP(1.494)*((B38)^1.108)*(((B38^(-0.018))^(LN(B38))))/1000)","v":{"$error":"#DIV/0!"}}]
["Gain",{"$f":"B38-B37","v":0},{"$f":"C38-C37","v":0.5},{"$f":"D38-D37","v":0},{"$f":"E38-E37","v":0},{"$f":"F38-F37","v":{"$error":"#DIV/0!"}}]
[]
[]
["Table 4. Weaner feed excreta calculations"]
["Source: ","Tables 1, 3,10, and Pig 01"]
["This table contains the retention and excretion calculations for weaners.  "]
[]
["Element","Intake (kg/pig)","Excreted (kg/pig)","Retained in body mass (%)","Batches","Excreted (kg/place/year)","P to P2O5","Effect of Phytase "]
["Nitrogen",{"$f":"B27","v":0},{"$f":"B47-E39","v":0},{"$f":"(E39/B47)*100","v":{"$error":"#DIV/0!"}},{"$f":"365/(SUM('Herd input details'!$D$20:$D$21))","v":{"$error":"#DIV/0!"}},{"$f":"C47*E47","v":{"$error":"#DIV/0!"}},"N/A","N/A"]
["Phosphorus",{"$f":"C27","v":0},{"$f":"B48-F39","v":{"$error":"#DIV/0!"}},{"$f":"(F39/B48)*100","v":{"$error":"#DIV/0!"}},{"$f":"365/(SUM('Herd input details'!$D$20:$D$21))","v":{"$error":"#DIV/0!"}},{"$f":"C48*E48","v":{"$error":"#DIV/0!"}},{"$f":"F48/0.437","v":{"$error":"#DIV/0!"}},{"$f":"IF(B124=TRUE,(G48*E116),(G48))","v":{"$error":"#DIV/0!"}}]
[]
[]
["Table 5. Fattener feed input calculations"]
["Source: ","Pig 01 and Herd input details"]
["This table contains the feed input calculations for fattener phase."]
[]
["Progress in phase","Weight (kg)","Protein in body mass (%)","Protein in body mass (kg)","Nitrogen in body mass (kg)","Phosphorus in body mass (kg)"]
["Start of phase",{"$f":"'Herd input details'!D15","v":0},18.600000000000001,{"$f":"B56*C56*0.01","v":0},{"$f":"D56/6.25","v":0},{"$f":"+(EXP(1.494)*((B56)^1.108)*(((B56^(-0.018))^(LN(B56))))/1000)","v":{"$error":"#DIV/0!"}}]
["End of phase (transfer)",{"$f":"'Herd input details'!D16","v":0},18.600000000000001,{"$f":"B57*C57*0.01","v":0},{"$f":"D57/6.25","v":0},{"$f":"+(EXP(1.494)*((B57)^1.108)*(((B57^(-0.018))^(LN(B57))))/1000)","v":{"$error":"#DIV/0!"}}]
["Gain",{"$f":"B57-B56","v":0},{"$f":"C57-C56","v":0},{"$f":"D57-D56","v":0},{"$f":"E57-E56","v":0},{"$f":"F57-F56","v":{"$error":"#DIV/0!"}}]
[]
[]
["Table 6. Fattener feed excreta calculations"]
["Source: ","Tables 1, 5, 10, and Pig 01"]
["This table contains the retention and excretion calculations for fattener phase."]
[]
["Element","Intake (kg/pig)","Excreted (kg/pig)","Retained in body mass (%)","Batches","Excreted (kg/place/year)","P to P2O5","Effect of Phytase "]
["Nitrogen",{"$f":"B28","v":0},{"$f":"B66-E58","v":0},{"$f":"(E58/B66)*100","v":{"$error":"#DIV/0!"}},{"$f":"365/(SUM('Herd input details'!$D$22:$D$23))","v":{"$error":"#DIV/0!"}},{"$f":"C66*E66","v":{"$error":"#DIV/0!"}},"N/A","N/A"]
["Phosphorus",{"$f":"C28","v":0},{"$f":"B67-F58","v":{"$error":"#DIV/0!"}},{"$f":"(F58/B67)*100","v":{"$error":"#DIV/0!"}},{"$f":"365/(SUM('Herd input details'!$D$22:$D$23))","v":{"$error":"#DIV/0!"}},{"$f":"C67*E67","v":{"$error":"#DIV/0!"}},{"$f":"F67/0.437","v":{"$error":"#DIV/0!"}},{"$f":"IF(B125=TRUE,(G67*E116),G67)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Table 7. Sow + Piglets feed input calculations"]
["Source: ","Table 1, Pig 01, and Herd input details"]
["This table contains the feed input calculations for sow and piglets.  "]
[]
["Pigs sold per sow per year"]
[{"$f":"'Herd input details'!D7","v":0}]
[]
["Nutrient kg","Protein (kg)","Nitrogen (kg)","Phosphorus (kg)"]
["Pig at weaning (kg/pig)",{"$f":"D37","v":0},{"$f":"B78/6.25","v":0},{"$f":"F37","v":{"$error":"#DIV/0!"}}]
["In piglets (kg/sow/annum)",{"$f":"B78*$A$75","v":0},{"$f":"C78*$A$75","v":0},{"$f":"D78*$A$75","v":{"$error":"#DIV/0!"}}]
[]
[]
["Sow and gilt gains","Weight (kg)","Protein in body mass (%)","Protein (kg)","Nitrogen (kg)","Phosphorus (kg)"]
["Gilt",{"$f":"'Herd input details'!D9","v":0},18,{"$f":"C83*B83*0.01","v":0},{"$f":"D83/6.25","v":0},{"$f":"(EXP(1.494)*((B83)^1.108)*(((B83^(-0.018))^(LN(B83))))/1000)","v":{"$error":"#DIV/0!"}}]
["Sow",{"$f":"'Herd input details'!D10","v":0},16,{"$f":"C84*B84*0.01","v":0},{"$f":"D84/6.25","v":0},{"$f":"(EXP(1.494)*((B84)^1.108)*(((B84^(-0.018))^(LN(B84))))/1000)","v":{"$error":"#DIV/0!"}}]
["Gain",{"$f":"B84-B83","v":0},{"$f":"C84-C83","v":-2},{"$f":"D84-D83","v":0},{"$f":"E84-E83","v":0},{"$f":"F84-F83","v":{"$error":"#DIV/0!"}}]
["Gain in sow herd",null,null,null,{"$f":"E85*'Herd input details'!$D$8*0.01","v":0},{"$f":"F85*'Herd input details'!$D$8*0.01","v":{"$error":"#DIV/0!"}}]
[]
["Total gains","Nitrogen (kg)","Phosphorus (kg)"]
["Total Gain (kg/sow+piglets/annum)",{"$f":"C79+E86","v":0},{"$f":"D79+F86","v":{"$error":"#DIV/0!"}}]
[]
[]
["Table 8. Sow + Piglets feed excreta calculations"]
["Source: ","Table 7, 10"]
["This table contains the retention and excretion calculations for sow and piglets.  "]
[]
["Element","Intake (kg/place/annum)","Excreted (kg/place/annum)","Retained (%)","Excreted (kg/place/year)","P to P2O5","Effect of Phytase "]
["Nitrogen",{"$f":"B29*A75","v":0},{"$f":"B97-B89","v":0},{"$f":"(B89/B97)*100","v":{"$error":"#DIV/0!"}},{"$f":"C97*'Herd input details'!$D$5/'Herd input details'!$D$6","v":{"$error":"#DIV/0!"}},"N/A","N/A"]
["Phosphorus",{"$f":"C29*A75","v":0},{"$f":"B98-C89","v":{"$error":"#DIV/0!"}},{"$f":"(C89/B98)*100","v":{"$error":"#DIV/0!"}},{"$f":"C98*'Herd input details'!$D$5/'Herd input details'!$D$6","v":{"$error":"#DIV/0!"}},{"$f":"C98/0.437","v":{"$error":"#DIV/0!"}},{"$f":"IF(B126=TRUE,(F98*E116),F98)","v":{"$error":"#DIV/0!"}}]
[]
["Table 9. BAT Calculations"]
["Source: ","N/A"]
["This table contains the calculations of the percentage of the BAT upper limits which has been used in the model"]
[]
[null,"BAT Limits",null,"% of BAT utilised"]
["Type","N (BAT limits)","P2O5 (BAT limits)","N (% BAT utilised)","P2O5 (% BAT utilised)"]
["Weaner",4,2.2000000000000002,{"$f":"(F47/B106)*100","v":{"$error":"#DIV/0!"}},{"$f":"(H48/C106)*100","v":{"$error":"#DIV/0!"}}]
["Fattener",13,5.4,{"$f":"(F66/B107)*100","v":{"$error":"#DIV/0!"}},{"$f":"(H67/C107)*100","v":{"$error":"#DIV/0!"}}]
["Sow + piglets",30,15,{"$f":"(C97/B108)*100","v":0},{"$f":"(G98/C108)*100","v":{"$error":"#DIV/0!"}}]
[]
[]
["Table 10. Effect of Phytase addition"]
["Source: ","Pig 03"]
["This table contains the calculations of the phytase reduction factor which is taken from the data in Pig 03."]
[]
["Column1","Phytase present in diet","Phytase absent in diet ","Reduction in excreted P (%)","Reduction Factor"]
["Faecal Phosphorous as (%) of Intake",95.7,118.7,{"$f":"((B116-C116)/C116)*100","v":-19.376579612468408},{"$f":"(100+D116)/100","v":0.80623420387531597}]
[]
[]
["Table 11. Selection of phytase"]
["Source: ","Diet input details"]
["This table connected to the tickboxes in 'Dies input details' and will show up as true or false depending on if the tickboxes are connected or not.  These cells are reference in the calculations above to include or not the effect of phytase on the excretion."]
[]
["Type","True/False"]
["Weaner",false]
["Fattener",false]
["Sow + piglets",false]